| FaAcademicYear |
| Logical Entity Name | FaAcademicYear |
| Default Table Name | FaAcademicYear |
| Physical Only | NO |
| Definition | |
| Note |
| FaAcademicYear Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
FaAcademicYearID |
int | NO | ||
| Code | char(8) | NO | ||
| Descrip | varchar(40) | NO | ||
FaPackMethID |
int | YES | ||
| DefaultWeeksInAY | smallint | YES | ||
| DefaultWeeksNonEnroll | smallint | YES | ||
| NumDisbPell | smallint | YES | ||
| NumDisbGrant | smallint | YES | ||
| NumDisbLoan | smallint | YES | ||
| NumDisbPerkins | smallint | YES | ||
| NumDisbOther | smallint | YES | ||
| NumDisbWS | smallint | YES | ||
| Disb1PctPell | numeric(6, 2) | YES | ||
| Disb2PctPell | numeric(6, 2) | YES | ||
| Disb3PctPell | numeric(6, 2) | YES | ||
| Disb4PctPell | numeric(6, 2) | YES | ||
| Disb5PctPell | numeric(6, 2) | YES | ||
| Disb1PctGrant | numeric(6, 2) | YES | ||
| Disb2PctGrant | numeric(6, 2) | YES | ||
| Disb3PctGrant | numeric(6, 2) | YES | ||
| Disb4PctGrant | numeric(6, 2) | YES | ||
| Disb5PctGrant | numeric(6, 2) | YES | ||
| Disb1PctLoan | numeric(6, 2) | YES | ||
| Disb2PctLoan | numeric(6, 2) | YES | ||
| Disb3PctLoan | numeric(6, 2) | YES | ||
| Disb4PctLoan | numeric(6, 2) | YES | ||
| Disb5PctLoan | numeric(6, 2) | YES | ||
| Disb1PctPerkins | numeric(6, 2) | YES | ||
| Disb2PctPerkins | numeric(6, 2) | YES | ||
| Disb3PctPerkins | numeric(6, 2) | YES | ||
| Disb4PctPerkins | numeric(6, 2) | YES | ||
| Disb5PctPerkins | numeric(6, 2) | YES | ||
| Disb1PctOther | numeric(6, 2) | YES | ||
| Disb2PctOther | numeric(6, 2) | YES | ||
| Disb3PctOther | numeric(6, 2) | YES | ||
| Disb4PctOther | numeric(6, 2) | YES | ||
| Disb5PctOther | numeric(6, 2) | YES | ||
| Disb1PctWS | numeric(6, 2) | YES | ||
| Disb2PctWS | numeric(6, 2) | YES | ||
| Disb3PctWS | numeric(6, 2) | YES | ||
| Disb4PctWS | numeric(6, 2) | YES | ||
| Disb5PctWS | numeric(6, 2) | YES | ||
| Active | bit | NO | ||
| UserID | int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
| Disb10PctLoan | numeric(6, 2) | YES | ||
| Disb10PctPell | numeric(6, 2) | YES | ||
| Disb11PctLoan | numeric(6, 2) | YES | ||
| Disb11PctPell | numeric(6, 2) | YES | ||
| Disb12PctLoan | numeric(6, 2) | YES | ||
| Disb12PctPell | numeric(6, 2) | YES | ||
| Disb13PctLoan | numeric(6, 2) | YES | ||
| Disb13PctPell | numeric(6, 2) | YES | ||
| Disb14PctLoan | numeric(6, 2) | YES | ||
| Disb14PctPell | numeric(6, 2) | YES | ||
| Disb15PctLoan | numeric(6, 2) | YES | ||
| Disb15PctPell | numeric(6, 2) | YES | ||
| Disb16PctLoan | numeric(6, 2) | YES | ||
| Disb17PctLoan | numeric(6, 2) | YES | ||
| Disb18PctLoan | numeric(6, 2) | YES | ||
| Disb19PctLoan | numeric(6, 2) | YES | ||
| Disb20PctLoan | numeric(6, 2) | YES | ||
| Disb6PctGrant | numeric(6, 2) | YES | ||
| Disb6PctLoan | numeric(6, 2) | YES | ||
| Disb6PctOther | numeric(6, 2) | YES | ||
| Disb6PctPell | numeric(6, 2) | YES | ||
| Disb6PctPerkins | numeric(6, 2) | YES | ||
| Disb6PctWS | numeric(6, 2) | YES | ||
| Disb7PctLoan | numeric(6, 2) | YES | ||
| Disb7PctPell | numeric(6, 2) | YES | ||
| Disb8PctLoan | numeric(6, 2) | YES | ||
| Disb8PctPell | numeric(6, 2) | YES | ||
| Disb9PctLoan | numeric(6, 2) | YES | ||
| Disb9PctPell | numeric(6, 2) | YES | ||
| DefaultMonthsinAY | smallint | YES | ||
| DefaultTermsInAY | smallint | NO |
| FaAcademicYear Primary and Unique Keys |
| Key Name | Key Type | Keys |
| FaAcademicYear_FaAcademicYearID_U_C_IDX | PrimaryKey | FaAcademicYearID |
| FaAcademicYear Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| FaPackMeth | Non-Identifying | Zero or One to Zero or More | FK_FaAcademicYear_FaPackMethID_FaPackMeth_FaPackMethID | FaPackMethID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| FaAcademicYearPP | Non-Identifying | One To Zero or More | FK_FaAcademicYearPP_FaAcademicYearID_FaAcademicYear_FaAcademicYearID | NO | YES |
| FaAcademicYear Check Constraints |
| Check Constraint Name | CheckConstraint |